﻿using System;

namespace edowork.com.Model
{
    #region purchaseplandetailInfo

        [Serializable]
        public class purchaseplandetailInfo
        {
            #region Private fields

            protected string _pspid = String.Empty;
            protected string _productcode = String.Empty;
            protected decimal _qty1;
            protected decimal _qty2;
            protected decimal _in_price;
            protected decimal _in_money;

            #endregion

            public purchaseplandetailInfo() { }

            #region Public Properties

            public string Pspid
            {
                get { return _pspid; }
                set { _pspid = value; }
            }

            public string Productcode
            {
                get { return _productcode; }
                set { _productcode = value; }
            }

            public decimal Qty1
            {
                get { return _qty1; }
                set { _qty1 = value; }
            }

            public decimal Qty2
            {
                get { return _qty2; }
                set { _qty2 = value; }
            }

            public decimal In_price
            {
                get { return _in_price; }
                set { _in_price = value; }
            }

            public decimal In_money
            {
                get { return _in_money; }
                set { _in_money = value; }
            }

            #endregion

            #region Public SQL Script

            public string SQL_Insert()
            {
                return "insert into purchaseplandetail(Pspid,Productcode,Qty1,Qty2,In_price,In_money) values('{0}','{1}',{2},{3},{4},{5})";
            }

            #endregion

        }

        #endregion
}

